<!DOCTYPE html>




<html class="theme-next gemini" lang="zh-Hans">
<head>
  <meta charset="UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"/>
<meta name="theme-color" content="#222">









<meta http-equiv="Cache-Control" content="no-transform" />
<meta http-equiv="Cache-Control" content="no-siteapp" />















  
  
  <link href="/lib/fancybox/source/jquery.fancybox.css?v=2.1.5" rel="stylesheet" type="text/css" />




  
  
  
  

  
    
    
  

  

  

  

  

  
    
    
    <link href="//fonts.googleapis.com/css?family=Lato:300,300italic,400,400italic,700,700italic&subset=latin,latin-ext" rel="stylesheet" type="text/css">
  






<link href="/lib/font-awesome/css/font-awesome.min.css?v=4.6.2" rel="stylesheet" type="text/css" />

<link href="/css/main.css?v=5.1.2" rel="stylesheet" type="text/css" />


  <meta name="keywords" content="教程,excel," />





  <link rel="alternate" href="/atom.xml" title="cyf 小博客" type="application/atom+xml" />




  <link rel="shortcut icon" type="image/x-icon" href="/images/favicon.ico?v=5.1.2" />






<meta property="og:type" content="article">
<meta property="og:title" content="可视化项目流程使用手册">
<meta property="og:url" content="http://cyf-my.gitee.io/2020/07/01/visual-progress-sheet-end-manual/index.html">
<meta property="og:site_name" content="cyf 小博客">
<meta property="article:published_time" content="2020-07-01T13:03:05.000Z">
<meta property="article:modified_time" content="2020-07-08T05:06:26.281Z">
<meta property="article:author" content="cyf">
<meta property="article:tag" content="教程">
<meta property="article:tag" content="excel">
<meta name="twitter:card" content="summary">



<script type="text/javascript" id="hexo.configurations">
  var NexT = window.NexT || {};
  var CONFIG = {
    root: '/',
    scheme: 'Gemini',
    sidebar: {"position":"left","display":"post","offset":12,"offset_float":12,"b2t":true,"scrollpercent":true,"onmobile":false},
    fancybox: true,
    tabs: true,
    motion: false,
    duoshuo: {
      userId: '0',
      author: '博主'
    },
    algolia: {
      applicationID: '',
      apiKey: '',
      indexName: '',
      hits: {"per_page":10},
      labels: {"input_placeholder":"Search for Posts","hits_empty":"We didn't find any results for the search: ${query}","hits_stats":"${hits} results found in ${time} ms"}
    }
  };
</script>



  <link rel="canonical" href="http://cyf-my.gitee.io/2020/07/01/visual-progress-sheet-end-manual/"/>





  <title>可视化项目流程使用手册 | cyf 小博客</title>
  














<meta name="generator" content="Hexo 4.2.1"></head>

<body itemscope itemtype="http://schema.org/WebPage" lang="zh-Hans">

  
  
    
  

  <div class="container sidebar-position-left page-post-detail ">
    <div class="headband"></div>
<a href="https://github.com/cyf-gh" target="_blank" rel="noopener" class="github-corner" aria-label="View source on GitHub"><svg width="80" height="80" viewBox="0 0 250 250" style="fill:#151513; color:#fff; position: absolute; top: 0; border: 0; right: 0;" aria-hidden="true"><path d="M0,0 L115,115 L130,115 L142,142 L250,250 L250,0 Z"></path><path d="M128.3,109.0 C113.8,99.7 119.0,89.6 119.0,89.6 C122.0,82.7 120.5,78.6 120.5,78.6 C119.2,72.0 123.4,76.3 123.4,76.3 C127.3,80.9 125.5,87.3 125.5,87.3 C122.9,97.6 130.6,101.9 134.4,103.2" fill="currentColor" style="transform-origin: 130px 106px;" class="octo-arm"></path><path d="M115.0,115.0 C114.9,115.1 118.7,116.5 119.8,115.4 L133.7,101.6 C136.9,99.2 139.9,98.4 142.2,98.6 C133.8,88.0 127.5,74.4 143.8,58.0 C148.5,53.4 154.0,51.2 159.7,51.0 C160.3,49.4 163.2,43.6 171.4,40.1 C171.4,40.1 176.1,42.5 178.8,56.2 C183.1,58.6 187.2,61.8 190.9,65.4 C194.5,69.0 197.7,73.2 200.1,77.6 C213.8,80.2 216.3,84.9 216.3,84.9 C212.7,93.1 206.9,96.0 205.4,96.6 C205.1,102.4 203.0,107.8 198.3,112.5 C181.9,128.9 168.3,122.5 157.7,114.1 C157.9,116.9 156.7,120.9 152.7,124.9 L141.0,136.5 C139.8,137.7 141.6,141.9 141.8,141.8 Z" fill="currentColor" class="octo-body"></path></svg></a><style>.github-corner:hover .octo-arm{animation:octocat-wave 560ms ease-in-out}@keyframes octocat-wave{0%,100%{transform:rotate(0)}20%,60%{transform:rotate(-25deg)}40%,80%{transform:rotate(10deg)}}@media (max-width:500px){.github-corner:hover .octo-arm{animation:none}.github-corner .octo-arm{animation:octocat-wave 560ms ease-in-out}}</style>
    <header id="header" class="header" itemscope itemtype="http://schema.org/WPHeader">
      <div class="header-inner"><div class="site-brand-wrapper">
  <div class="site-meta ">
    

    <div class="custom-logo-site-title">
      <a href="/"  class="brand" rel="start">
        <span class="logo-line-before"><i></i></span>
        <span class="site-title">cyf 小博客</span>
        <span class="logo-line-after"><i></i></span>
      </a>
    </div>
      
        <p class="site-subtitle">不会写文，文笔很差。</p>
      
  </div>

  <div class="site-nav-toggle">
    <button>
      <span class="btn-bar"></span>
      <span class="btn-bar"></span>
      <span class="btn-bar"></span>
    </button>
  </div>
</div>

<nav class="site-nav">
  

  
    <ul id="menu" class="menu">
      
        
        <li class="menu-item menu-item-home">
          <a href="/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-home"></i> <br />
            
            首页
          </a>
        </li>
      
        
        <li class="menu-item menu-item-categories">
          <a href="/categories/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-th"></i> <br />
            
            分类
          </a>
        </li>
      
        
        <li class="menu-item menu-item-archives">
          <a href="/archives/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-archive"></i> <br />
            
            归档
          </a>
        </li>
      
        
        <li class="menu-item menu-item-tags">
          <a href="/tags/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-tags"></i> <br />
            
            标签
          </a>
        </li>
      

      
    </ul>
  

  
</nav>



 </div>
    </header>

    <main id="main" class="main">
      <div class="main-inner">
        <div class="content-wrap">
          <div id="content" class="content">
            

  <div id="posts" class="posts-expand">
    

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="http://cyf-my.gitee.io/2020/07/01/visual-progress-sheet-end-manual/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="cyf">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="cyf 小博客">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline">可视化项目流程使用手册</h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">发表于</span>
              
              <time title="创建于" itemprop="dateCreated datePublished" datetime="2020-07-01T21:03:05+08:00">
                2020-07-01
              </time>
            

            

            
          </span>

          
            <span class="post-category" >
            
              <span class="post-meta-divider">|</span>
            
              <span class="post-meta-item-icon">
                <i class="fa fa-folder-o"></i>
              </span>
              
                <span class="post-meta-item-text">分类于</span>
              
              
                <span itemprop="about" itemscope itemtype="http://schema.org/Thing">
                  <a href="/categories/%E4%BD%BF%E7%94%A8%E6%89%8B%E5%86%8C/" itemprop="url" rel="index">
                    <span itemprop="name">使用手册</span>
                  </a>
                </span>

                
                
              
            </span>
          

          
            
          

          
          <!--
          
             <span id="/2020/07/01/visual-progress-sheet-end-manual/" class="leancloud_visitors" data-flag-title="可视化项目流程使用手册">
               <span class="post-meta-divider">|</span>
               <span class="post-meta-item-icon">
                 <i class="fa fa-eye"></i>
               </span>
               
                 <span class="post-meta-item-text">阅读次数<span class="leancloud-visitors-count"></span> </span>
               
                 
             </span>
          
          -->
          
            <span class="post-meta-divider">|</span>
              <span class="post-meta-item-icon">
                <i class="fa fa-eye"></i>
              </span>
            <span class="busuanzi-value" id="busuanzi_value_page_pv" ></span>
            </span>
          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        <hr>
<a id="more"></a>

<h2 id="0-序"><a href="#0-序" class="headerlink" title="0 序"></a>0 序</h2><p>本文试图使用文字描述整个表格文件如何正常运作，如果表格出现了错误，可以按照条款逐条进行点检。</p>
<h3 id="0-1-如何使用本文"><a href="#0-1-如何使用本文" class="headerlink" title="0.1 如何使用本文"></a>0.1 如何使用本文</h3><p>进行一般的操作，请找到你要操作的表格，并阅读 <strong>设计中的操作</strong> 节，这个小节在每个表格中都会出现。</p>
<p>如果发生了表格不正常工作的情况，请阅读 <strong>意外的操作</strong> 节，这个小节在每个表格中都会出现。同时在 <strong>设计中的操作</strong> 节中也会提到意外的操作。</p>
<p>如果实在不行，请尝试用正常工作的备份文件从头开始或联系我</p>
<blockquote>
<p><a href="mailto:cyf-ms@hotmail.com">cyf-ms@hotmail.com</a></p>
</blockquote>
<h3 id="0-2-我使用时需要注意"><a href="#0-2-我使用时需要注意" class="headerlink" title="0.2 我使用时需要注意"></a>0.2 我使用时需要注意</h3><ol>
<li><p>进行正常工作版本文件的<strong>备份</strong>，防止手头表格无法工作时没有备份版本的尴尬情况。</p>
</li>
<li><p>如何让同步操作生效？</p>
<p>本文多次强调：</p>
</li>
</ol>
<blockquote>
<p><u><strong>点击</strong>位于<strong>具体步骤表格</strong>或<strong>参考流程打分表格</strong>中的任意一格进行应用。</u></p>
</blockquote>
<p>​    这是优化的缘故，表格设计成防止按任意一格触发数据同步事件，从而产生巨大的卡顿。</p>
<h3 id="0-3-主要叙述对象一览"><a href="#0-3-主要叙述对象一览" class="headerlink" title="0.3 主要叙述对象一览"></a>0.3 主要叙述对象一览</h3><p>主要有代码和用户操作出现的表格为：</p>
<ul>
<li>F-J 的<strong>具体步骤表格</strong></li>
<li>K-M 的<strong>参考流程打分表格</strong></li>
<li><strong>折线图</strong></li>
</ul>
<h2 id="1-参考流程打分表格"><a href="#1-参考流程打分表格" class="headerlink" title="1 参考流程打分表格"></a>1 参考流程打分表格</h2><h3 id="1-1-设计中的操作"><a href="#1-1-设计中的操作" class="headerlink" title="1.1 设计中的操作"></a>1.1 设计中的操作</h3><ul>
<li>修改进度值</li>
</ul>
<p>参考流程打分表格被设计为是静态的，不允许表格内添加与减少项目。</p>
<h4 id="1-1-1-数据的修改"><a href="#1-1-1-数据的修改" class="headerlink" title="1.1.1 数据的修改"></a>1.1.1 数据的修改</h4><ol>
<li>修改进度值（M列）</li>
<li>并<u><strong>点击</strong>位于<strong>具体步骤表格</strong>或<strong>参考流程打分表格</strong>中的任意一格进行应用。</u></li>
<li>检查<strong>参考流程打分表格</strong>数据是否正常同步</li>
</ol>
<h3 id="1-2-意外的操作"><a href="#1-2-意外的操作" class="headerlink" title="1.2 意外的操作"></a>1.2 <del>意外的操作</del></h3><h4 id="1-2-1-添加或删除一行数据"><a href="#1-2-1-添加或删除一行数据" class="headerlink" title="1.2.1 添加或删除一行数据"></a>1.2.1 添加或删除一行数据</h4><ol>
<li><p>在表格内添加或删除插入一行数据，让数据行往上移动或往下移动。</p>
</li>
<li><p>打开vba代码编辑，将 <strong>prototype_range</strong> 的值改为目前表的大小。</p>
<p>你修改的代码行应该形如：</p>
<p><code>prototype_range = &quot;K34:M54&quot;</code></p>
</li>
<li><p>CTRL+S 或保存vba代码，回到excel表格观察是否正常工作。</p>
</li>
</ol>
<h2 id="2-具体步骤表格"><a href="#2-具体步骤表格" class="headerlink" title="2 具体步骤表格"></a>2 <strong>具体步骤表格</strong></h2><h3 id="2-1-设计中的操作"><a href="#2-1-设计中的操作" class="headerlink" title="2.1 设计中的操作"></a>2.1 设计中的操作</h3><ul>
<li>添加一行数据</li>
<li>删除一行数据</li>
<li>无此步骤</li>
<li>取消无此步骤</li>
</ul>
<p>被设计为参考流程打分值的隶属表格，除去时间进度值被设计为无法修改。</p>
<h4 id="2-1-1-添加或删除一行数据"><a href="#2-1-1-添加或删除一行数据" class="headerlink" title="2.1.1 添加或删除一行数据"></a>2.1.1 添加或删除一行数据</h4><ol>
<li><p>在表格内添加一行数据</p>
</li>
<li><p>将步骤名改为你想要添加的步骤的名字</p>
<p><strong>注：如果此时没有发生进度值的同步，请先检查步骤名称是否完全相同。</strong></p>
</li>
<li><p>并<u><strong>点击</strong>位于<strong>具体步骤表格</strong>或<strong>参考流程打分表格</strong>中的任意一格进行应用。</u></p>
</li>
<li><p>检查<strong>参考流程打分表格</strong>数据是否正常同步</p>
</li>
</ol>
<p>   如此时发生例如<strong>最后几行数据没有显示在折线图中</strong>的情况，意味着可能超出了设计表格的范围。</p>
<p>   如需要具体操作请阅读 <strong>2.2</strong> 节</p>
<p>已经不需要拖动任何的表格进行应用即可正常运行。</p>
<h4 id="2-1-2-添加【无此步骤】"><a href="#2-1-2-添加【无此步骤】" class="headerlink" title="2.1.2 添加【无此步骤】"></a>2.1.2 添加【无此步骤】</h4><ol>
<li>在需要无此步骤的一行的备注一列中填入字符：</li>
</ol>
<p><code>【无此步骤】</code></p>
<p>​        <strong>注：字符需完全相同。</strong></p>
<ol start="2">
<li><p><u><strong>点击</strong>位于<strong>具体步骤表格</strong>或<strong>参考流程打分表格</strong>中的任意一格进行应用。</u></p>
<p>此时，步骤一栏将自动填写【无此步骤】前缀，进度也将会与上一行的数据相同。</p>
<ol start="3">
<li>检查<strong>参考流程打分表格</strong>数据是否正常变动</li>
</ol>
</li>
</ol>
<h4 id="2-1-3-取消【无此步骤】"><a href="#2-1-3-取消【无此步骤】" class="headerlink" title="2.1.3 取消【无此步骤】"></a>2.1.3 取消【无此步骤】</h4><pre><code>1. 首先将目标行的“【无此步骤】”备注清空
 2. 将步骤中的“【无此步骤】”前缀删除，或直接填写该步骤
 3. &lt;u&gt;**点击**位于**具体步骤表格**或**参考流程打分表格**中的任意一格进行应用。&lt;/u&gt;
 4. 检查**参考流程打分表格**数据是否正常变动</code></pre><h3 id="2-2-意外的操作"><a href="#2-2-意外的操作" class="headerlink" title="2.2 意外的操作"></a><del>2.2 意外的操作</del></h3><h4 id="2-2-1-表格过长"><a href="#2-2-1-表格过长" class="headerlink" title="2.2.1 表格过长"></a>2.2.1 表格过长</h4><p>接 2.1.1 节的文字，当你输入的最后几行数据不显示在折线图中时，可能是<strong>参考流程打分表格</strong>过长（虽然这种情况很难发生）</p>
<p>发生这种情况时，你需要：</p>
<ol>
<li><p>打开vba编辑器</p>
</li>
<li><p>找到 target_range 变量，修改他的值为你当前表格的长度范围</p>
<p>你修改的代码行应该形如</p>
<p><code>target_range = &quot;F2:J40&quot;</code></p>
</li>
<li><p>CTRL+S 或保存vba代码，回到excel表格观察是否正常工作。</p>
</li>
</ol>
<h2 id="3-折线图"><a href="#3-折线图" class="headerlink" title="3 折线图"></a>3 折线图</h2><h3 id="3-1-设计中的操作"><a href="#3-1-设计中的操作" class="headerlink" title="3.1 设计中的操作"></a>3.1 设计中的操作</h3><p>折线图被设计为完全静态，出去一个拖动数据标签防止其重叠导致看不清的操作。</p>
<h4 id="3-1-1-移动数据标签"><a href="#3-1-1-移动数据标签" class="headerlink" title="3.1.1 移动数据标签"></a>3.1.1 移动数据标签</h4><ol>
<li>先点击你需要移动的数据标签，此时可以看到选中了所有的标签。</li>
<li>再次点击你需要移动的数据标签，此时可以看到只选中了这个标签。</li>
<li>将鼠标放置在边缘上并显示出上下左右的指针形状。</li>
<li>拖动至你想要拖动的地方。</li>
</ol>
<h3 id="3-2-意外的操作"><a href="#3-2-意外的操作" class="headerlink" title="3.2 意外的操作"></a><del>3.2 意外的操作</del></h3><h4 id="3-2-1-删除，或变动了其中某一个数据标签"><a href="#3-2-1-删除，或变动了其中某一个数据标签" class="headerlink" title="3.2.1 删除，或变动了其中某一个数据标签"></a>3.2.1 删除，或变动了其中某一个数据标签</h4><p>i.e. 数据标签已无法与表格内的数据一一同步，或显示有错误</p>
<ol>
<li>点击任意数据标签，点击delete或是删除键删除。</li>
<li>右击某个节点，点击<strong>添加数据标签</strong></li>
<li>再次点击任意数据标签，选中所有标签</li>
<li>右击，选择 <strong>设置数据标签格式</strong></li>
<li>寻找到 标签选项 -&gt; 标签包括中 </li>
<li>勾选<strong>单元格中的值</strong>，将值设为<strong>G行</strong> </li>
<li>取消 <strong>值(V)</strong> 的勾选</li>
<li>寻找到 数据标签 -&gt; 标签位置选择 <strong>靠上</strong></li>
<li>再次点击标签，选中所有并右击，更改数据标签形状，选择一个形状。</li>
<li>完成标签的重新生成</li>
</ol>

      
    </div>
    
    
    
    <!--添加版权信息-->
    <div>
        
        
<div class="my_post_copyright">
  <script src="//cdn.bootcss.com/clipboard.js/1.5.10/clipboard.min.js"></script>
  
  <!-- JS库 sweetalert 可修改路径 -->
  <script type="text/javascript" src="http://jslibs.wuxubj.cn/sweetalert_mini/jquery-1.7.1.min.js"></script>
  <script src="http://jslibs.wuxubj.cn/sweetalert_mini/sweetalert.min.js"></script>
  <link rel="stylesheet" type="text/css" href="http://jslibs.wuxubj.cn/sweetalert_mini/sweetalert.mini.css">

  <p><span>本文标题:</span>可视化项目流程使用手册</a></p>
  <p><span>文章作者:</span>cyf</a></p>
  <p><span>发布时间:</span>2020年07月01日 - 21:03:05</p>
  <p><span>最后更新:</span>2020年07月08日 - 13:06:26</p>
  <p><span>原始链接:</span><a href="/2020/07/01/visual-progress-sheet-end-manual/" title="可视化项目流程使用手册">http://cyf-my.gitee.io/2020/07/01/visual-progress-sheet-end-manual/</a>
    <span class="copy-path"  title="点击复制文章链接"><i class="fa fa-clipboard" data-clipboard-text="http://cyf-my.gitee.io/2020/07/01/visual-progress-sheet-end-manual/"  aria-label="复制成功！"></i></span>
  </p>
  <p><span>许可协议:</span><i class="fa fa-creative-commons"></i> <a rel="license" href="https://creativecommons.org/licenses/by-nc-nd/4.0/" target="_blank" title="Attribution-NonCommercial-NoDerivatives 4.0 International (CC BY-NC-ND 4.0)">署名-非商业性使用-禁止演绎 4.0 国际</a> 转载请保留原文链接及作者。</p>  
</div>
<script> 
    var clipboard = new Clipboard('.fa-clipboard');
    clipboard.on('success', $(function(){
      $(".fa-clipboard").click(function(){
        swal({   
          title: "",   
          text: '复制成功',   
          html: false,
          timer: 500,   
          showConfirmButton: false
        });
      });
    }));  
</script>

        
    </div>
    
    

    

    

    <footer class="post-footer">
      
        <div class="post-tags">
          
            <a href="/tags/%E6%95%99%E7%A8%8B/" rel="tag"># 教程</a>
          
            <a href="/tags/excel/" rel="tag"># excel</a>
          
        </div>
      

      
      
      

      
        <div class="post-nav">
          <div class="post-nav-next post-nav-item">
            
              <a href="/2020/06/27/register_skin_and_server_activate/" rel="next" title="皮肤注册与服务器验证教程">
                <i class="fa fa-chevron-left"></i> 皮肤注册与服务器验证教程
              </a>
            
          </div>

          <span class="post-nav-divider"></span>

          <div class="post-nav-prev post-nav-item">
            
              <a href="/2020/07/08/iphone-4-dual-os-dig/" rel="prev" title="iPhone 4 coolbootercli 双系统安装踩坑">
                iPhone 4 coolbootercli 双系统安装踩坑 <i class="fa fa-chevron-right"></i>
              </a>
            
          </div>
        </div>
      

      
      
    </footer>
  </div>
  
  
  
  </article>



    <div class="post-spread">
      
    </div>
  </div>


          </div>
          


          
  <div class="comments" id="comments">
    
  </div>


        </div>
        
          
  
  <div class="sidebar-toggle">
    <div class="sidebar-toggle-line-wrap">
      <span class="sidebar-toggle-line sidebar-toggle-line-first"></span>
      <span class="sidebar-toggle-line sidebar-toggle-line-middle"></span>
      <span class="sidebar-toggle-line sidebar-toggle-line-last"></span>
    </div>
  </div>

  <aside id="sidebar" class="sidebar">
    
    <div class="sidebar-inner">

      

      
        <ul class="sidebar-nav motion-element">
          <li class="sidebar-nav-toc sidebar-nav-active" data-target="post-toc-wrap" >
            文章目录
          </li>
          <li class="sidebar-nav-overview" data-target="site-overview">
            站点概览
          </li>
        </ul>
      

      <section class="site-overview sidebar-panel">
        <div class="site-author motion-element" itemprop="author" itemscope itemtype="http://schema.org/Person">
          <img class="site-author-image" itemprop="image"
               src="/images/avatar.gif"
               alt="cyf" />
          <p class="site-author-name" itemprop="name">cyf</p>
           
              <p class="site-description motion-element" itemprop="description"></p>
          
        </div>
        <nav class="site-state motion-element">

          
            <div class="site-state-item site-state-posts">
              <a href="/archives/">
                <span class="site-state-item-count">6</span>
                <span class="site-state-item-name">日志</span>
              </a>
            </div>
          

          
            
            
            <div class="site-state-item site-state-categories">
              <a href="/categories/index.html">
                <span class="site-state-item-count">5</span>
                <span class="site-state-item-name">分类</span>
              </a>
            </div>
          

          
            
            
            <div class="site-state-item site-state-tags">
              <a href="/tags/index.html">
                <span class="site-state-item-count">13</span>
                <span class="site-state-item-name">标签</span>
              </a>
            </div>
          

        </nav>

        
          <div class="feed-link motion-element">
            <a href="/atom.xml" rel="alternate">
              <i class="fa fa-rss"></i>
              RSS
            </a>
          </div>
        

        <div class="links-of-author motion-element">
          
            
              <span class="links-of-author-item">
                <a href="https://www.cyf-cloud.cn" target="_blank" title="cyf-cloud">
                  
                    <i class="fa fa-fw fa-globe"></i>
                  
                    
                      cyf-cloud
                    
                </a>
              </span>
            
              <span class="links-of-author-item">
                <a href="https://se.cyf-cloud.cn:8228" target="_blank" title="cyf-mc">
                  
                    <i class="fa fa-fw fa-globe"></i>
                  
                    
                      cyf-mc
                    
                </a>
              </span>
            
              <span class="links-of-author-item">
                <a href="https://space.bilibili.com/3087782" target="_blank" title="哔哩哔哩">
                  
                    <i class="fa fa-fw fa-globe"></i>
                  
                    
                      哔哩哔哩
                    
                </a>
              </span>
            
              <span class="links-of-author-item">
                <a href="https://github.com/cyf-gh || github" target="_blank" title="GitHub">
                  
                    <i class="fa fa-fw fa-github"></i>
                  
                    
                      GitHub
                    
                </a>
              </span>
            
              <span class="links-of-author-item">
                <a href="mailto:cyf-ms@hotmail.com || envelope" target="_blank" title="E-Mail">
                  
                    <i class="fa fa-fw fa-envelope"></i>
                  
                    
                      E-Mail
                    
                </a>
              </span>
            
          
        </div>

        
        

        
        

        


      </section>

      
      <!--noindex-->
        <section class="post-toc-wrap motion-element sidebar-panel sidebar-panel-active">
          <div class="post-toc">

            
              
            

            
              <div class="post-toc-content"><ol class="nav"><li class="nav-item nav-level-2"><a class="nav-link" href="#0-序"><span class="nav-text">0 序</span></a><ol class="nav-child"><li class="nav-item nav-level-3"><a class="nav-link" href="#0-1-如何使用本文"><span class="nav-text">0.1 如何使用本文</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#0-2-我使用时需要注意"><span class="nav-text">0.2 我使用时需要注意</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#0-3-主要叙述对象一览"><span class="nav-text">0.3 主要叙述对象一览</span></a></li></ol></li><li class="nav-item nav-level-2"><a class="nav-link" href="#1-参考流程打分表格"><span class="nav-text">1 参考流程打分表格</span></a><ol class="nav-child"><li class="nav-item nav-level-3"><a class="nav-link" href="#1-1-设计中的操作"><span class="nav-text">1.1 设计中的操作</span></a><ol class="nav-child"><li class="nav-item nav-level-4"><a class="nav-link" href="#1-1-1-数据的修改"><span class="nav-text">1.1.1 数据的修改</span></a></li></ol></li><li class="nav-item nav-level-3"><a class="nav-link" href="#1-2-意外的操作"><span class="nav-text">1.2 意外的操作</span></a><ol class="nav-child"><li class="nav-item nav-level-4"><a class="nav-link" href="#1-2-1-添加或删除一行数据"><span class="nav-text">1.2.1 添加或删除一行数据</span></a></li></ol></li></ol></li><li class="nav-item nav-level-2"><a class="nav-link" href="#2-具体步骤表格"><span class="nav-text">2 具体步骤表格</span></a><ol class="nav-child"><li class="nav-item nav-level-3"><a class="nav-link" href="#2-1-设计中的操作"><span class="nav-text">2.1 设计中的操作</span></a><ol class="nav-child"><li class="nav-item nav-level-4"><a class="nav-link" href="#2-1-1-添加或删除一行数据"><span class="nav-text">2.1.1 添加或删除一行数据</span></a></li><li class="nav-item nav-level-4"><a class="nav-link" href="#2-1-2-添加【无此步骤】"><span class="nav-text">2.1.2 添加【无此步骤】</span></a></li><li class="nav-item nav-level-4"><a class="nav-link" href="#2-1-3-取消【无此步骤】"><span class="nav-text">2.1.3 取消【无此步骤】</span></a></li></ol></li><li class="nav-item nav-level-3"><a class="nav-link" href="#2-2-意外的操作"><span class="nav-text">2.2 意外的操作</span></a><ol class="nav-child"><li class="nav-item nav-level-4"><a class="nav-link" href="#2-2-1-表格过长"><span class="nav-text">2.2.1 表格过长</span></a></li></ol></li></ol></li><li class="nav-item nav-level-2"><a class="nav-link" href="#3-折线图"><span class="nav-text">3 折线图</span></a><ol class="nav-child"><li class="nav-item nav-level-3"><a class="nav-link" href="#3-1-设计中的操作"><span class="nav-text">3.1 设计中的操作</span></a><ol class="nav-child"><li class="nav-item nav-level-4"><a class="nav-link" href="#3-1-1-移动数据标签"><span class="nav-text">3.1.1 移动数据标签</span></a></li></ol></li><li class="nav-item nav-level-3"><a class="nav-link" href="#3-2-意外的操作"><span class="nav-text">3.2 意外的操作</span></a><ol class="nav-child"><li class="nav-item nav-level-4"><a class="nav-link" href="#3-2-1-删除，或变动了其中某一个数据标签"><span class="nav-text">3.2.1 删除，或变动了其中某一个数据标签</span></a></li></ol></li></ol></li></ol></div>
            

          </div>
        </section>
      <!--/noindex-->
      

      
        <div class="back-to-top">
          <i class="fa fa-arrow-up"></i>
          
            <span id="scrollpercent"><span>0</span>%</span>
          
        </div>
      

    </div>
  </aside>


        
      </div>
    </main>

    <footer id="footer" class="footer">
      <div class="footer-inner">
        <div class="copyright" >
  
  &copy; 
  <span itemprop="copyrightYear">2020</span>
  <span class="with-love">
    <i class="fa fa-heart"></i>
  </span>
  <span class="author" itemprop="copyrightHolder">cyf</span>
</div>

<!--

<div class="powered-by">
  由 <a class="theme-link" href="https://hexo.io" target="_blank" rel="noopener">Hexo</a> 强力驱动
</div>

<div class="theme-info">
  主题 -
  <a class="theme-link" href="https://github.com/iissnan/hexo-theme-next" target="_blank" rel="noopener">
    NexT.Gemini
  </a>
</div>
-->
<i class="fa">千里之行，始于足下。</i>

<!--
<span id="busuanzi_container_site_uv">
  本站总访客数:<span id="busuanzi_value_site_uv"></span>&nbsp;&nbsp;| 
</span>
<span id="busuanzi_container_site_pv">
    &nbsp;本站总访问量<span id="busuanzi_value_site_pv"></span>次
</span>
</div>
</div>
-->




<script async src="//busuanzi.ibruce.info/busuanzi/2.3/busuanzi.pure.mini.js"></script>
        
<div class="busuanzi-count">
  <script async src="https://dn-lbstatics.qbox.me/busuanzi/2.3/busuanzi.pure.mini.js"></script>

  
    <span class="site-uv">
      <i class="fa fa-user"></i>
      <span class="busuanzi-value" id="busuanzi_value_site_uv"></span>
      
    </span>
  

  
    <span class="site-pv">
      <i class="fa fa-eye"></i>
      <span class="busuanzi-value" id="busuanzi_value_site_pv"></span>
      
    </span>
  
</div>


        
      </div>
    </footer>

    

  </div>

  

<script type="text/javascript">
  if (Object.prototype.toString.call(window.Promise) !== '[object Function]') {
    window.Promise = null;
  }
</script>









  












  
  <script type="text/javascript" src="/lib/jquery/index.js?v=2.1.3"></script>

  
  <script type="text/javascript" src="/lib/fastclick/lib/fastclick.min.js?v=1.0.6"></script>

  
  <script type="text/javascript" src="/lib/jquery_lazyload/jquery.lazyload.js?v=1.9.7"></script>

  
  <script type="text/javascript" src="/lib/velocity/velocity.min.js?v=1.2.1"></script>

  
  <script type="text/javascript" src="/lib/velocity/velocity.ui.min.js?v=1.2.1"></script>

  
  <script type="text/javascript" src="/lib/fancybox/source/jquery.fancybox.pack.js?v=2.1.5"></script>


  


  <script type="text/javascript" src="/js/src/utils.js?v=5.1.2"></script>

  <script type="text/javascript" src="/js/src/motion.js?v=5.1.2"></script>



  
  


  <script type="text/javascript" src="/js/src/affix.js?v=5.1.2"></script>

  <script type="text/javascript" src="/js/src/schemes/pisces.js?v=5.1.2"></script>



  
  <script type="text/javascript" src="/js/src/scrollspy.js?v=5.1.2"></script>
<script type="text/javascript" src="/js/src/post-details.js?v=5.1.2"></script>



  


  <script type="text/javascript" src="/js/src/bootstrap.js?v=5.1.2"></script>



  


  




	





  





  






  





  

  
  <script src="https://cdn1.lncld.net/static/js/av-core-mini-0.6.4.js"></script>
  <script>AV.initialize("Ykhx1csKCHE3CshrgXg8jIen-gzGzoHsz", "K8bboleYujuh7TO85MSttpvX");</script>
  <script>
    function showTime(Counter) {
      var query = new AV.Query(Counter);
      var entries = [];
      var $visitors = $(".leancloud_visitors");

      $visitors.each(function () {
        entries.push( $(this).attr("id").trim() );
      });

      query.containedIn('url', entries);
      query.find()
        .done(function (results) {
          var COUNT_CONTAINER_REF = '.leancloud-visitors-count';

          if (results.length === 0) {
            $visitors.find(COUNT_CONTAINER_REF).text(0);
            return;
          }

          for (var i = 0; i < results.length; i++) {
            var item = results[i];
            var url = item.get('url');
            var time = item.get('time');
            var element = document.getElementById(url);

            $(element).find(COUNT_CONTAINER_REF).text(time);
          }
          for(var i = 0; i < entries.length; i++) {
            var url = entries[i];
            var element = document.getElementById(url);
            var countSpan = $(element).find(COUNT_CONTAINER_REF);
            if( countSpan.text() == '') {
              countSpan.text(0);
            }
          }
        })
        .fail(function (object, error) {
          console.log("Error: " + error.code + " " + error.message);
        });
    }

    function addCount(Counter) {
      var $visitors = $(".leancloud_visitors");
      var url = $visitors.attr('id').trim();
      var title = $visitors.attr('data-flag-title').trim();
      var query = new AV.Query(Counter);

      query.equalTo("url", url);
      query.find({
        success: function(results) {
          if (results.length > 0) {
            var counter = results[0];
            counter.fetchWhenSave(true);
            counter.increment("time");
            counter.save(null, {
              success: function(counter) {
                var $element = $(document.getElementById(url));
                $element.find('.leancloud-visitors-count').text(counter.get('time'));
              },
              error: function(counter, error) {
                console.log('Failed to save Visitor num, with error message: ' + error.message);
              }
            });
          } else {
            var newcounter = new Counter();
            /* Set ACL */
            var acl = new AV.ACL();
            acl.setPublicReadAccess(true);
            acl.setPublicWriteAccess(true);
            newcounter.setACL(acl);
            /* End Set ACL */
            newcounter.set("title", title);
            newcounter.set("url", url);
            newcounter.set("time", 1);
            newcounter.save(null, {
              success: function(newcounter) {
                var $element = $(document.getElementById(url));
                $element.find('.leancloud-visitors-count').text(newcounter.get('time'));
              },
              error: function(newcounter, error) {
                console.log('Failed to create');
              }
            });
          }
        },
        error: function(error) {
          console.log('Error:' + error.code + " " + error.message);
        }
      });
    }

    $(function() {
      var Counter = AV.Object.extend("Counter");
      if ($('.leancloud_visitors').length == 1) {
        addCount(Counter);
      } else if ($('.post-title-link').length > 1) {
        showTime(Counter);
      }
    });
  </script>



  
<script>
(function(){
    var bp = document.createElement('script');
    var curProtocol = window.location.protocol.split(':')[0];
    if (curProtocol === 'https') {
        bp.src = 'https://zz.bdstatic.com/linksubmit/push.js';        
    }
    else {
        bp.src = 'http://push.zhanzhang.baidu.com/push.js';
    }
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(bp, s);
})();
</script>


  

  

  

  

</body>
</html>

<!-- 页面点击小红心 -->
<script type="text/javascript" src="/js/src/clicklove.js"></script>